FirstRow

Note: This statement is named First Recordset Row in the Add Statement dialog box.

Makes the first row in a recordset the active row.

Syntax

FirstRow(Recordset)

Arguments

Argument Description
Recordset Recordset name. Must be opened with OpenRecordset or OpenRecordsetQuery.

Example

rs = OpenRecordset("WysiCorp Bugs (Excel)")

FirstRow(rs)

While Not RecordsetEOF(rs)

PrintLn(GetRowValue(rs, "First Name"))

NextRow(rs)

WEnd